package cn.tedu.jdbc;

import java.sql.*;
import java.util.Scanner;

public class JDBCDemo1 {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
       /*
       1 加载数据库的驱动
       2创建数据库的连接对象
       3创建SQL语句的执行对象
       4执行SQL语句
       5断开数据库链接释放资源
       */
        Class.forName("com.mysql.cj.jdbc.Driver");

        Connection connection = DriverManager.getConnection(
                "jdbc:mysql://localhost:3306/tedu?characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai&rewriteBatchedStatements=true",
                "root",
                "123456"
        );

        Statement statement = connection.createStatement();

        Scanner scanner = new Scanner(System.in);
        System.out.println("用户名");
        String username=scanner.nextLine();
        System.out.println("密码");
        String password=scanner.nextLine();
        System.out.println("昵称");
        String nickname=scanner.nextLine();
        System.out.println("年龄");
        Integer age=scanner.nextInt();

        String sql="INSERT INTO userinfo( username, password, nickname, age)\n" +
          "VALUES ('"+username+"','"+password+"','"+nickname+"',"+age+")";

          int i=statement.executeUpdate(sql);
//
//        ResultSet

          connection.close();;
    }
}
